/****** Object:  Stored Procedure dbo.spr_LoadAllDBCompaniess  ******/

 use [TourIS]
 GO

 if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[spr_LoadAllDBCompaniess]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
 drop procedure [dbo].[spr_LoadAllDBCompaniess]
 GO

 SET QUOTED_IDENTIFIER OFF
 GO
 SET ANSI_NULLS OFF
 GO

 CREATE  PROCEDURE [dbo].[spr_LoadAllDBCompaniess]
 AS

 BEGIN
	SET NOCOUNT ON
	DECLARE @Err int

	SELECT
		[Address],
		[CompId],
		[CompName],
		[CompTitle],
		[ContactNos],
		[ContactPerson],
		[DealExpiryDate],
		[DealStartDate],
		[IsActive],
		[Remarks]
		FROM [Companies]

	SET @Err = @@Error
	RETURN @Err
 END

 GO

 SET QUOTED_IDENTIFIER OFF
 GO
 SET ANSI_NULLS ON
 GO

